using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlTypes;
using System.Data.SqlClient;
using System.Text;
using ECommerce.DAL;


namespace Entity
{
	
    public partial class TblProductPurchaseOrderItems_ForMultipleShipping
    {
        public static CustomCollection<TblProductPurchaseOrderItems_ForMultipleShipping> GetTblProductPurchaseOrderItems_ByMultipleShippingInfoId(Int32 productPurchaseOrderItems_ForMultipleShippingId)
        {
            if (productPurchaseOrderItems_ForMultipleShippingId <= GetProductPurchaseOrderItems_ForMultipleShippingIdMinValue)
                throw (new ArgumentOutOfRangeException("productPurchaseOrderItems_ForMultipleShippingId"));

            // Execute SQL Command
            SqlCommand sqlCmd = new SqlCommand();
            AddParameterToSqlCmd(sqlCmd, "@ProductPurchaseOrderItems_ForMultipleShippingId", SqlDbType.Int, 0, ParameterDirection.Input, productPurchaseOrderItems_ForMultipleShippingId);
            SetCommandType(sqlCmd, CommandType.StoredProcedure, "GetTblProductPurchaseOrderItem_ForMultipleShippingInfoId");
            GenerateCollectionFromReader test = new GenerateCollectionFromReader(GenerateTblProductPurchaseOrderItems_ForMultipleShippingCollectionFromReader);
            CustomCollection<TblProductPurchaseOrderItems_ForMultipleShipping> objCollection = ((CustomCollection<TblProductPurchaseOrderItems_ForMultipleShipping>)ExecuteReaderCmd(sqlCmd, test));
            return objCollection;
        }
		
	}
}	
